"Sort (cost=4091.92..4091.93 rows=1 width=83) (actual time=22003.849..22004.041 rows=458 loops=1)" " Sort Key: to_char((coitem.coitem_scheddate)::timestamp with time zone, 'Month Dy DD YYYY'::text), cohead.cohead_number, coitem.coitem_linenumber" " -> Nested Loop Left Join (cost=0.00..4091.91 rows=1 width=83) (actual time=14.477..21998.119 rows=458 loops=1)" " -> Nested Loop (cost=0.00..191.54 rows=1 width=75) (actual time=0.132..32.066 rows=458 loops=1)" " -> Nested Loop (cost=0.00..191.22 rows=1 width=44) (actual time=0.121..25.253 rows=458 loops=1)" " -> Nested Loop (cost=0.00..182.94 rows=1 width=40) (actual time=0.111..18.476 rows=458 loops=1)" " -> Nested Loop (cost=0.00..182.53 rows=1 width=30) (actual time=0.100..11.662 rows=458 loops=1)" " -> Index Scan using coitem_status_key on coitem (cost=0.00..174.25 rows=1 width=30) (actual time=0.084..2.364 rows=458 loops=1)" " Index Cond: (coitem_status = 'O'::bpchar)" " Filter: ((coitem_scheddate >= '2008-01-01'::date) AND (coitem_scheddate <= '2008-12-31'::date))" " -> Index Scan using itemsite_pkey on itemsite (cost=0.00..8.27 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=458)" " Index Cond: (coitem.coitem_itemsite_id = itemsite.itemsite_id)" " -> Index Scan using item_pkey on item (cost=0.00..0.40 rows=1 width=18) (actual time=0.008..0.010 rows=1 loops=458)" " Index Cond: (itemsite.itemsite_item_id = item.item_id)" " -> Index Scan using cohead_pkey on cohead (cost=0.00..8.27 rows=1 width=12) (actual time=0.008..0.010 rows=1 loops=458)" " Index Cond: (cohead.cohead_id = coitem.coitem_cohead_id)" " -> Index Scan using cust_pkey on custinfo (cost=0.00..0.31 rows=1 width=39) (actual time=0.007..0.009 rows=1 loops=458)" " Index Cond: (cohead.cohead_cust_id = custinfo.cust_id)" " -> Index Scan using wo_pkey on wo (cost=0.00..8.27 rows=1 width=12) (actual time=0.007..0.011 rows=1 loops=458)" " Index Cond: (wo.wo_id = coitem.coitem_order_id)" " SubPlan" " -> Nested Loop (cost=958.43..1975.22 rows=1 width=36) (actual time=22.607..22.955 rows=1 loops=419)" " Join Filter: (wrkcnt.wrkcnt_id = wooper.wooper_wrkcnt_id)" " InitPlan" " -> Aggregate (cost=958.42..958.43 rows=1 width=4) (actual time=13.870..13.870 rows=1 loops=419)" " -> Seq Scan on wooper (cost=0.00..958.41 rows=1 width=4) (actual time=13.453..13.856 rows=1 loops=419)" " Filter: (wooper_rncomplete AND (wooper_wo_id = $0))" " -> Seq Scan on wooper (cost=0.00..1013.10 rows=1 width=8) (actual time=22.547..22.821 rows=1 loops=419)" " Filter: ((wooper_seqnumber = $1) AND (wooper_wo_id = $0))" " -> Seq Scan on wrkcnt (cost=0.00..2.75 rows=75 width=36) (actual time=0.010..0.052 rows=75 loops=419)" " -> Aggregate (cost=958.42..958.43 rows=1 width=4) (actual time=14.033..14.034 rows=1 loops=419)" " -> Seq Scan on wooper (cost=0.00..958.41 rows=1 width=4) (actual time=13.600..14.011 rows=1 loops=419)" " Filter: (wooper_rncomplete AND (wooper_wo_id = $0))" " -> Aggregate (cost=958.42..958.43 rows=1 width=4) (actual time=14.058..14.059 rows=1 loops=458)" " -> Seq Scan on wooper (cost=0.00..958.41 rows=1 width=4) (actual time=13.671..14.043 rows=1 loops=458)" " Filter: (wooper_rncomplete AND (wooper_wo_id = $0))" "Total runtime: 22005.075 ms"